Round 1: Coding BPS (Business Process Screen)

🔹1 Hard Difficulty SQL Question: Be prepared for complex SQL challenges.

🔹Deep Dive Questions on Spark Internals: Understand the core components and operations of Spark.

Round 2: Coding & SQL

🔹1 Hard Difficulty SQL Question: Expect a challenging SQL problem to solve.

🔹1 Medium Difficulty DSA Question: Focus on these eight topics: Arrays, Strings, Stacks, Queues, Linked Lists, Recursion, Binary Search, and Basic 1D Dynamic Programming.

Round 3: Data Modeling

🔹Task: Build a Data Model for an everyday app, such as a ride-hailing or food delivery service.

🔹Discussion Points: Fact/dimension tables, bridge tables, star/snowflake schema, slowly changing dimensions.

🔹SQL Queries: Write SQL queries against the data model and discuss their complexities.

Round 4: System Design

🔹Scenario: Design end-to-end architectures for use cases like an executive dashboard, building data marts, or a streaming pipeline.

🔹Key Considerations: Clarify functional and non-functional requirements, discuss scalability, file formats, ingestion tools, and database choices (relational vs. non-relational).

🔹Best Practices: Highlight best practices in system design.

Round 5: Collaboration & Leadership

🔹Topics of Discussion: Leadership styles, handling failures, resolving conflicts, celebrating achievements, managing differences in opinions.

🔹Exit Reasons: Discuss why you are considering leaving your current company.